package com.ctvit.sms.platform.domain;

import java.util.Date;

import com.ctvit.framework.domain.BaseBean;

/**
 * domain类
 * SELECT
 * a.f_msg_sub_cat,
 * a.f_msg_sub_cat_name,
 * a.f_msg_description,
 * a.f_is_use AS f_msg_sub_cat_is_use,
 * b.f_is_use AS f_msg_category_is_use,
 * c.f_is_open AS f_user_subs_is_open,
 * c.f_is_able AS f_user_subs_is_able,
 * a.f_status AS f_msg_sub_cat_status,
 * b.f_status AS f_msg_category_status
 * FROM
 * t_msg_sub_cat AS a
 * INNER JOIN
 * t_msg_category AS b ON a.f_msg_category = b.f_msg_category
 * LEFT JOIN
 * (SELECT
 * f_user_id, f_msg_sub_cat,f_is_open, f_is_able
 * FROM
 * t_user_subs
 * WHERE
 * f_user_id = '00104060'  ) AS c ON a.f_msg_sub_cat = c.f_msg_sub_cat
 * WHERE
 * a.f_msg_category = 'MAK'
 * AND a.f_is_use = 0
 * AND b.f_is_use = 0
 * AND a.f_status = 1
 * AND b.f_status = 1
 * ORDER BY a.f_sort_index ASC
 * ;
 */
public class SubCateWithUserSubs extends BaseBean {
	/*
	* 字段:     f_msg_sub_cat 
	* 数据库类型:VARCHAR 
	* 说明:     null
	* 
	*/
	private String msgSubCat;
	/*
	* 字段:     f_msg_sub_cat_name 
	* 数据库类型:VARCHAR 
	* 说明:     null
	* 
	*/
	private String msgSubCatName;
	/*
	* 字段:     f_msg_description 
	* 数据库类型:VARCHAR 
	* 说明:     null
	* 
	*/
	private String msgDescription;
	/*
	* 字段:     f_msg_sub_cat_is_use 
	* 数据库类型:TINYINT 
	* 说明:     null
	* 
	*/
	private Integer msgSubCatIsUse;
	/*
	* 字段:     f_msg_category_is_use 
	* 数据库类型:TINYINT 
	* 说明:     null
	* 
	*/
	private Integer msgCategoryIsUse;
	/*
	* 字段:     f_user_subs_is_open
	* 数据库类型:TINYINT 
	* 说明:     null
	* 
	*/
	private Integer userSubsIsOpen;
	/*
	* 字段:     f_user_subs_is_able
	* 数据库类型:TINYINT
	* 说明:     null
	*
	*/
	private Integer userSubsIsAble;
	/*
	* 字段:     f_msg_sub_cat_status
	* 数据库类型:TINYINT
	* 说明:     null
	*
	*/
	private Integer msgSubCatStatus;
	/*
	* 字段:     f_msg_category_status
	* 数据库类型:TINYINT
	* 说明:     null
	*
	*/
	private Integer msgCategoryStatus;

	/**
	 * null.
	 *
	 * @return MsgSubCat type:String
	 */
	public String getMsgSubCat() {
		return msgSubCat;
	}

	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setMsgSubCat(String newvalue) {
		this.msgSubCat = newvalue;
	}

	/**
	 * null.
	 *
	 * @return MsgSubCatName type:String
	 */
	public String getMsgSubCatName() {
		return msgSubCatName;
	}

	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setMsgSubCatName(String newvalue) {
		this.msgSubCatName = newvalue;
	}

	/**
	 * null.
	 *
	 * @return MsgDescription type:String
	 */
	public String getMsgDescription() {
		return msgDescription;
	}

	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setMsgDescription(String newvalue) {
		this.msgDescription = newvalue;
	}

	/**
	 * null.
	 *
	 * @return MsgSubCatIsUse type:Integer
	 */
	public Integer getMsgSubCatIsUse() {
		return msgSubCatIsUse;
	}

	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setMsgSubCatIsUse(Integer newvalue) {
		this.msgSubCatIsUse = newvalue;
	}

	/**
	 * null.
	 *
	 * @return MsgCategoryIsUse type:Integer
	 */
	public Integer getMsgCategoryIsUse() {
		return msgCategoryIsUse;
	}

	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setMsgCategoryIsUse(Integer newvalue) {
		this.msgCategoryIsUse = newvalue;
	}

	/**
	 * null.
	 *
	 * @return UserSubsIsOpen type:Integer
	 */
	public Integer getUserSubsIsOpen() {
		return userSubsIsOpen;
	}

	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setUserSubsIsOpen(Integer newvalue) {
		this.userSubsIsOpen = newvalue;
	}

	/**
	 * null.
	 *
	 * @return UserSubsIsAble type:Integer
	 */
	public Integer getUserSubsIsAble() {
		return userSubsIsAble;
	}

	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setUserSubsIsAble(Integer newvalue) {
		this.userSubsIsAble = newvalue;
	}

	/**
	 * null.
	 *
	 * @return MsgSubCatStatus type:Integer
	 */
	public Integer getMsgSubCatStatus() {
		return msgSubCatStatus;
	}

	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setMsgSubCatStatus(Integer newvalue) {
		this.msgSubCatStatus = newvalue;
	}

	/**
	 * null.
	 *
	 * @return MsgSubCatStatus type:Integer
	 */
	public Integer getMsgCategoryStatus() {
		return msgCategoryStatus;
	}

	/**
	 * null.
	 *
	 * @param newvalue
	 */
	public void setMsgCategoryStatus(Integer newvalue) {
		this.msgCategoryStatus = newvalue;
	}
}

